{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['.ipynb_checkpoints',\n",
       " 'ad_operation.dat',\n",
       " 'ad_operate.ipynb',\n",
       " 'ad_static_feature.h5']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "os.listdir('.')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper = pd.read_csv('ad_operation.dat', sep='\\t', header=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>593323</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>593323</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>all</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>593323</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>281474976710655,281474976710655,28147497671065...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>593323</td>\n",
       "      <td>20190217000000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>593323</td>\n",
       "      <td>20190218233855</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        0               1  2  3  \\\n",
       "0  593323               0  2  2   \n",
       "1  593323               0  2  3   \n",
       "2  593323               0  2  4   \n",
       "3  593323  20190217000000  1  1   \n",
       "4  593323  20190218233855  1  2   \n",
       "\n",
       "                                                   4  \n",
       "0                                                 90  \n",
       "1                                                all  \n",
       "2  281474976710655,281474976710655,28147497671065...  \n",
       "3                                                  0  \n",
       "4                                                 90  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ad_oper.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 760866 entries, 0 to 760865\n",
      "Data columns (total 5 columns):\n",
      "0    760866 non-null int64\n",
      "1    760866 non-null int64\n",
      "2    760866 non-null int64\n",
      "3    760866 non-null int64\n",
      "4    760866 non-null object\n",
      "dtypes: int64(4), object(1)\n",
      "memory usage: 29.0+ MB\n"
     ]
    }
   ],
   "source": [
    "ad_oper.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper.columns = ['ad-id', 'create-time', 'oper-type', 'field', 'value']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ad-id</th>\n",
       "      <th>create-time</th>\n",
       "      <th>oper-type</th>\n",
       "      <th>field</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>593323</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>593323</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>all</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>593323</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>281474976710655,281474976710655,28147497671065...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>593323</td>\n",
       "      <td>20190217000000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>593323</td>\n",
       "      <td>20190218233855</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ad-id     create-time  oper-type  field  \\\n",
       "0  593323               0          2      2   \n",
       "1  593323               0          2      3   \n",
       "2  593323               0          2      4   \n",
       "3  593323  20190217000000          1      1   \n",
       "4  593323  20190218233855          1      2   \n",
       "\n",
       "                                               value  \n",
       "0                                                 90  \n",
       "1                                                all  \n",
       "2  281474976710655,281474976710655,28147497671065...  \n",
       "3                                                  0  \n",
       "4                                                 90  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ad_oper.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([2, 1])"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ad_oper['oper-type'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([2, 3, 4, 1])"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ad_oper['field'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper_clean = ad_oper[ad_oper['create-time'] > 0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 647381 entries, 3 to 760605\n",
      "Data columns (total 5 columns):\n",
      "ad-id          647381 non-null int64\n",
      "create-time    647381 non-null int64\n",
      "oper-type      647381 non-null int64\n",
      "field          647381 non-null int64\n",
      "value          647381 non-null object\n",
      "dtypes: int64(4), object(1)\n",
      "memory usage: 29.6+ MB\n"
     ]
    }
   ],
   "source": [
    "ad_oper_clean.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ad-id</th>\n",
       "      <th>create-time</th>\n",
       "      <th>oper-type</th>\n",
       "      <th>field</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>593323</td>\n",
       "      <td>20190217000000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>593323</td>\n",
       "      <td>20190218233855</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>593323</td>\n",
       "      <td>20190218000000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>593323</td>\n",
       "      <td>20190230000000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>593323</td>\n",
       "      <td>20190301000000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ad-id     create-time  oper-type  field value\n",
       "3  593323  20190217000000          1      1     0\n",
       "4  593323  20190218233855          1      2    90\n",
       "5  593323  20190218000000          1      1     1\n",
       "6  593323  20190230000000          1      1     0\n",
       "7  593323  20190301000000          1      1     1"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ad_oper_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper_state = ad_oper_clean[ad_oper_clean['field'] == 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 499280 entries, 3 to 760602\n",
      "Data columns (total 5 columns):\n",
      "ad-id          499280 non-null int64\n",
      "create-time    499280 non-null int64\n",
      "oper-type      499280 non-null int64\n",
      "field          499280 non-null int64\n",
      "value          499280 non-null object\n",
      "dtypes: int64(4), object(1)\n",
      "memory usage: 22.9+ MB\n"
     ]
    }
   ],
   "source": [
    "ad_oper_state.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper_price = ad_oper_clean[ad_oper_clean['field'] == 2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 129977 entries, 4 to 760603\n",
      "Data columns (total 5 columns):\n",
      "ad-id          129977 non-null int64\n",
      "create-time    129977 non-null int64\n",
      "oper-type      129977 non-null int64\n",
      "field          129977 non-null int64\n",
      "value          129977 non-null object\n",
      "dtypes: int64(4), object(1)\n",
      "memory usage: 5.9+ MB\n"
     ]
    }
   ],
   "source": [
    "ad_oper_price.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper_time = ad_oper_clean[ad_oper_clean['field'] == 4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 8034 entries, 7400 to 760107\n",
      "Data columns (total 5 columns):\n",
      "ad-id          8034 non-null int64\n",
      "create-time    8034 non-null int64\n",
      "oper-type      8034 non-null int64\n",
      "field          8034 non-null int64\n",
      "value          8034 non-null object\n",
      "dtypes: int64(4), object(1)\n",
      "memory usage: 376.6+ KB\n"
     ]
    }
   ],
   "source": [
    "ad_oper_time.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper_group = ad_oper_clean[ad_oper_clean['field'] == 3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 10090 entries, 9646 to 760605\n",
      "Data columns (total 5 columns):\n",
      "ad-id          10090 non-null int64\n",
      "create-time    10090 non-null int64\n",
      "oper-type      10090 non-null int64\n",
      "field          10090 non-null int64\n",
      "value          10090 non-null object\n",
      "dtypes: int64(4), object(1)\n",
      "memory usage: 473.0+ KB\n"
     ]
    }
   ],
   "source": [
    "ad_oper_group.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ad-id</th>\n",
       "      <th>create-time</th>\n",
       "      <th>oper-type</th>\n",
       "      <th>field</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7400</th>\n",
       "      <td>233293</td>\n",
       "      <td>20190228001425</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>281474976645120,281474976645120,28147497664512...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7933</th>\n",
       "      <td>229385</td>\n",
       "      <td>20190303010855</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4397979402240,4397979402240,4397979402240,4397...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10271</th>\n",
       "      <td>67499</td>\n",
       "      <td>20190223233049</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>17592185782272,17592185782272,17592185782272,1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10282</th>\n",
       "      <td>67499</td>\n",
       "      <td>20190311220456</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>17592186028032,17592186028032,17592186028032,1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10375</th>\n",
       "      <td>710041</td>\n",
       "      <td>20190224232917</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>17592184995840,17592184995840,17592184995840,1...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        ad-id     create-time  oper-type  field  \\\n",
       "7400   233293  20190228001425          1      4   \n",
       "7933   229385  20190303010855          1      4   \n",
       "10271   67499  20190223233049          1      4   \n",
       "10282   67499  20190311220456          1      4   \n",
       "10375  710041  20190224232917          1      4   \n",
       "\n",
       "                                                   value  \n",
       "7400   281474976645120,281474976645120,28147497664512...  \n",
       "7933   4397979402240,4397979402240,4397979402240,4397...  \n",
       "10271  17592185782272,17592185782272,17592185782272,1...  \n",
       "10282  17592186028032,17592186028032,17592186028032,1...  \n",
       "10375  17592184995840,17592184995840,17592184995840,1...  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ad_oper_time.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "time_col_map = {0:'mon', 1:'tue', 2:'wed', 3:'thu', 4:'fri', 5:'sat', 6:'sun'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_week = ad_oper_time['value'].str.split(',', expand=True).rename(columns = time_col_map)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>mon</th>\n",
       "      <th>tue</th>\n",
       "      <th>wed</th>\n",
       "      <th>thu</th>\n",
       "      <th>fri</th>\n",
       "      <th>sat</th>\n",
       "      <th>sun</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7400</th>\n",
       "      <td>281474976645120</td>\n",
       "      <td>281474976645120</td>\n",
       "      <td>281474976645120</td>\n",
       "      <td>281474976645120</td>\n",
       "      <td>281474976645120</td>\n",
       "      <td>281474976645120</td>\n",
       "      <td>281474976645120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7933</th>\n",
       "      <td>4397979402240</td>\n",
       "      <td>4397979402240</td>\n",
       "      <td>4397979402240</td>\n",
       "      <td>4397979402240</td>\n",
       "      <td>4397979402240</td>\n",
       "      <td>274810798080</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10271</th>\n",
       "      <td>17592185782272</td>\n",
       "      <td>17592185782272</td>\n",
       "      <td>17592185782272</td>\n",
       "      <td>17592185782272</td>\n",
       "      <td>17592185782272</td>\n",
       "      <td>17592185782272</td>\n",
       "      <td>17592185782272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10282</th>\n",
       "      <td>17592186028032</td>\n",
       "      <td>17592186028032</td>\n",
       "      <td>17592186028032</td>\n",
       "      <td>17592186028032</td>\n",
       "      <td>17592186028032</td>\n",
       "      <td>17592186028032</td>\n",
       "      <td>17592186028032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10375</th>\n",
       "      <td>17592184995840</td>\n",
       "      <td>17592184995840</td>\n",
       "      <td>17592184995840</td>\n",
       "      <td>17592184995840</td>\n",
       "      <td>17592184995840</td>\n",
       "      <td>4398042316800</td>\n",
       "      <td>4398042316800</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   mon              tue              wed              thu  \\\n",
       "7400   281474976645120  281474976645120  281474976645120  281474976645120   \n",
       "7933     4397979402240    4397979402240    4397979402240    4397979402240   \n",
       "10271   17592185782272   17592185782272   17592185782272   17592185782272   \n",
       "10282   17592186028032   17592186028032   17592186028032   17592186028032   \n",
       "10375   17592184995840   17592184995840   17592184995840   17592184995840   \n",
       "\n",
       "                   fri              sat              sun  \n",
       "7400   281474976645120  281474976645120  281474976645120  \n",
       "7933     4397979402240     274810798080                0  \n",
       "10271   17592185782272   17592185782272   17592185782272  \n",
       "10282   17592186028032   17592186028032   17592186028032  \n",
       "10375   17592184995840    4398042316800    4398042316800  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_week.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "for col in df_week.columns:\n",
    "    df_week[col] = df_week[col].map(lambda r : '{:0>48b}'.format(int(r)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "for col in df_week.columns:\n",
    "    df_week[col] = df_week[col].map(lambda r : ' '.join(list(r)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>mon</th>\n",
       "      <th>tue</th>\n",
       "      <th>wed</th>\n",
       "      <th>thu</th>\n",
       "      <th>fri</th>\n",
       "      <th>sat</th>\n",
       "      <th>sun</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7400</th>\n",
       "      <td>1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7933</th>\n",
       "      <td>0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...</td>\n",
       "      <td>0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...</td>\n",
       "      <td>0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...</td>\n",
       "      <td>0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...</td>\n",
       "      <td>0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...</td>\n",
       "      <td>0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 0 ...</td>\n",
       "      <td>0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10271</th>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10282</th>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10375</th>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "      <td>0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     mon  \\\n",
       "7400   1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "7933   0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...   \n",
       "10271  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10282  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10375  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "\n",
       "                                                     tue  \\\n",
       "7400   1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "7933   0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...   \n",
       "10271  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10282  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10375  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "\n",
       "                                                     wed  \\\n",
       "7400   1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "7933   0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...   \n",
       "10271  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10282  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10375  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "\n",
       "                                                     thu  \\\n",
       "7400   1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "7933   0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...   \n",
       "10271  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10282  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10375  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "\n",
       "                                                     fri  \\\n",
       "7400   1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "7933   0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 ...   \n",
       "10271  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10282  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10375  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "\n",
       "                                                     sat  \\\n",
       "7400   1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "7933   0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 0 ...   \n",
       "10271  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10282  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "10375  0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...   \n",
       "\n",
       "                                                     sun  \n",
       "7400   1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...  \n",
       "7933   0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ...  \n",
       "10271  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...  \n",
       "10282  0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...  \n",
       "10375  0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ...  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_week.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "for col in df_week.columns:\n",
    "    tmp = pd.concat([tmp, df_week[col].str.split(' ', expand=True).rename(\n",
    "                columns=lambda r : col + '-' + str(r))], axis=1, sort=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>mon-0</th>\n",
       "      <th>mon-1</th>\n",
       "      <th>mon-2</th>\n",
       "      <th>mon-3</th>\n",
       "      <th>mon-4</th>\n",
       "      <th>mon-5</th>\n",
       "      <th>mon-6</th>\n",
       "      <th>mon-7</th>\n",
       "      <th>mon-8</th>\n",
       "      <th>mon-9</th>\n",
       "      <th>...</th>\n",
       "      <th>sun-38</th>\n",
       "      <th>sun-39</th>\n",
       "      <th>sun-40</th>\n",
       "      <th>sun-41</th>\n",
       "      <th>sun-42</th>\n",
       "      <th>sun-43</th>\n",
       "      <th>sun-44</th>\n",
       "      <th>sun-45</th>\n",
       "      <th>sun-46</th>\n",
       "      <th>sun-47</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7400</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7933</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10271</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10282</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10375</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 336 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      mon-0 mon-1 mon-2 mon-3 mon-4 mon-5 mon-6 mon-7 mon-8 mon-9  ... sun-38  \\\n",
       "7400      1     1     1     1     1     1     1     1     1     1  ...      0   \n",
       "7933      0     0     0     0     0     0     1     1     1     1  ...      0   \n",
       "10271     0     0     0     0     1     1     1     1     1     1  ...      0   \n",
       "10282     0     0     0     0     1     1     1     1     1     1  ...      0   \n",
       "10375     0     0     0     0     1     1     1     1     1     1  ...      0   \n",
       "\n",
       "      sun-39 sun-40 sun-41 sun-42 sun-43 sun-44 sun-45 sun-46 sun-47  \n",
       "7400       0      0      0      0      0      0      0      0      0  \n",
       "7933       0      0      0      0      0      0      0      0      0  \n",
       "10271      0      0      0      0      0      0      0      0      0  \n",
       "10282      0      0      0      0      0      0      0      0      0  \n",
       "10375      0      0      0      0      0      0      0      0      0  \n",
       "\n",
       "[5 rows x 336 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['mon-0', 'mon-1', 'mon-2', 'mon-3', 'mon-4', 'mon-5', 'mon-6', 'mon-7',\n",
       "       'mon-8', 'mon-9',\n",
       "       ...\n",
       "       'sun-38', 'sun-39', 'sun-40', 'sun-41', 'sun-42', 'sun-43', 'sun-44',\n",
       "       'sun-45', 'sun-46', 'sun-47'],\n",
       "      dtype='object', length=336)"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_week_expand = tmp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>mon-0</th>\n",
       "      <th>mon-1</th>\n",
       "      <th>mon-2</th>\n",
       "      <th>mon-3</th>\n",
       "      <th>mon-4</th>\n",
       "      <th>mon-5</th>\n",
       "      <th>mon-6</th>\n",
       "      <th>mon-7</th>\n",
       "      <th>mon-8</th>\n",
       "      <th>mon-9</th>\n",
       "      <th>...</th>\n",
       "      <th>sun-38</th>\n",
       "      <th>sun-39</th>\n",
       "      <th>sun-40</th>\n",
       "      <th>sun-41</th>\n",
       "      <th>sun-42</th>\n",
       "      <th>sun-43</th>\n",
       "      <th>sun-44</th>\n",
       "      <th>sun-45</th>\n",
       "      <th>sun-46</th>\n",
       "      <th>sun-47</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7400</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7933</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10271</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10282</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10375</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 336 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      mon-0 mon-1 mon-2 mon-3 mon-4 mon-5 mon-6 mon-7 mon-8 mon-9  ... sun-38  \\\n",
       "7400      1     1     1     1     1     1     1     1     1     1  ...      0   \n",
       "7933      0     0     0     0     0     0     1     1     1     1  ...      0   \n",
       "10271     0     0     0     0     1     1     1     1     1     1  ...      0   \n",
       "10282     0     0     0     0     1     1     1     1     1     1  ...      0   \n",
       "10375     0     0     0     0     1     1     1     1     1     1  ...      0   \n",
       "\n",
       "      sun-39 sun-40 sun-41 sun-42 sun-43 sun-44 sun-45 sun-46 sun-47  \n",
       "7400       0      0      0      0      0      0      0      0      0  \n",
       "7933       0      0      0      0      0      0      0      0      0  \n",
       "10271      0      0      0      0      0      0      0      0      0  \n",
       "10282      0      0      0      0      0      0      0      0      0  \n",
       "10375      0      0      0      0      0      0      0      0      0  \n",
       "\n",
       "[5 rows x 336 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_week_expand.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper_time_new = ad_oper_time.join(df_week_expand).drop(['oper-type', 'field', 'value'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ad-id</th>\n",
       "      <th>create-time</th>\n",
       "      <th>mon-0</th>\n",
       "      <th>mon-1</th>\n",
       "      <th>mon-2</th>\n",
       "      <th>mon-3</th>\n",
       "      <th>mon-4</th>\n",
       "      <th>mon-5</th>\n",
       "      <th>mon-6</th>\n",
       "      <th>mon-7</th>\n",
       "      <th>...</th>\n",
       "      <th>sun-38</th>\n",
       "      <th>sun-39</th>\n",
       "      <th>sun-40</th>\n",
       "      <th>sun-41</th>\n",
       "      <th>sun-42</th>\n",
       "      <th>sun-43</th>\n",
       "      <th>sun-44</th>\n",
       "      <th>sun-45</th>\n",
       "      <th>sun-46</th>\n",
       "      <th>sun-47</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7400</th>\n",
       "      <td>233293</td>\n",
       "      <td>20190228001425</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7933</th>\n",
       "      <td>229385</td>\n",
       "      <td>20190303010855</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10271</th>\n",
       "      <td>67499</td>\n",
       "      <td>20190223233049</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10282</th>\n",
       "      <td>67499</td>\n",
       "      <td>20190311220456</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10375</th>\n",
       "      <td>710041</td>\n",
       "      <td>20190224232917</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 338 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ad-id     create-time mon-0 mon-1 mon-2 mon-3 mon-4 mon-5 mon-6 mon-7  \\\n",
       "7400   233293  20190228001425     1     1     1     1     1     1     1     1   \n",
       "7933   229385  20190303010855     0     0     0     0     0     0     1     1   \n",
       "10271   67499  20190223233049     0     0     0     0     1     1     1     1   \n",
       "10282   67499  20190311220456     0     0     0     0     1     1     1     1   \n",
       "10375  710041  20190224232917     0     0     0     0     1     1     1     1   \n",
       "\n",
       "       ... sun-38 sun-39 sun-40 sun-41 sun-42 sun-43 sun-44 sun-45 sun-46  \\\n",
       "7400   ...      0      0      0      0      0      0      0      0      0   \n",
       "7933   ...      0      0      0      0      0      0      0      0      0   \n",
       "10271  ...      0      0      0      0      0      0      0      0      0   \n",
       "10282  ...      0      0      0      0      0      0      0      0      0   \n",
       "10375  ...      0      0      0      0      0      0      0      0      0   \n",
       "\n",
       "      sun-47  \n",
       "7400       0  \n",
       "7933       0  \n",
       "10271      0  \n",
       "10282      0  \n",
       "10375      0  \n",
       "\n",
       "[5 rows x 338 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ad_oper_time_new.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 8034 entries, 7400 to 760107\n",
      "Columns: 338 entries, ad-id to sun-47\n",
      "dtypes: int64(2), object(336)\n",
      "memory usage: 21.1+ MB\n"
     ]
    }
   ],
   "source": [
    "ad_oper_time_new.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ad-id</th>\n",
       "      <th>create-time</th>\n",
       "      <th>oper-type</th>\n",
       "      <th>field</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9646</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190317174007</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>age:217,837,602,935,942,638,287,5,536,739,366,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9647</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102114</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>age:217,837,602,935,942,638,287,5,536,739,366,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9648</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102120</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>age:217,837,602,935,942,638,287,5,536,739,366,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9649</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102126</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>age:217,837,602,935,942,638,287,5,536,739,366,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9650</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102133</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>age:217,837,602,935,942,638,287,5,536,739,366,...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ad-id     create-time  oper-type  field  \\\n",
       "9646  70365  20190317174007          1      3   \n",
       "9647  70365  20190319102114          1      3   \n",
       "9648  70365  20190319102120          1      3   \n",
       "9649  70365  20190319102126          1      3   \n",
       "9650  70365  20190319102133          1      3   \n",
       "\n",
       "                                                  value  \n",
       "9646  age:217,837,602,935,942,638,287,5,536,739,366,...  \n",
       "9647  age:217,837,602,935,942,638,287,5,536,739,366,...  \n",
       "9648  age:217,837,602,935,942,638,287,5,536,739,366,...  \n",
       "9649  age:217,837,602,935,942,638,287,5,536,739,366,...  \n",
       "9650  age:217,837,602,935,942,638,287,5,536,739,366,...  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ad_oper_group.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_group = ad_oper_group['value'].str.split('|', expand=True).stack().reset_index(level=1, drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9646    age:217,837,602,935,942,638,287,5,536,739,366,...\n",
       "9646    area:9961,11693,14350,3022,2851,1138,11768,869...\n",
       "9646                                   connectionType:2,4\n",
       "9646    behavior:36079,29640,1173,36346,6563,606,6280,...\n",
       "9647    age:217,837,602,935,942,638,287,5,536,739,366,...\n",
       "dtype: object"
      ]
     },
     "execution_count": 127,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_group.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {},
   "outputs": [],
   "source": [
    "def fun(r):\n",
    "    prefix = r.split(':')[0]\n",
    "    if len(r.split(':')) < 2:\n",
    "        return None\n",
    "    vals = r.split(':')[1].split(',')\n",
    "    return ' '.join([prefix + '-' + val for val in vals])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_group = df_group.map(fun).dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_group_expand = df_group.str.split(' ', expand=True).stack().reset_index(level=1, drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_group_expand = pd.DataFrame(df_group_expand)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-136-4b66dbd32dfd>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf_group_expand\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_dummies\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdf_group_expand\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mprefix\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'group'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/core/reshape/reshape.py\u001b[0m in \u001b[0;36mget_dummies\u001b[0;34m(data, prefix, prefix_sep, dummy_na, columns, sparse, drop_first, dtype)\u001b[0m\n\u001b[1;32m    859\u001b[0m                                     drop_first=drop_first, dtype=dtype)\n\u001b[1;32m    860\u001b[0m             \u001b[0mwith_dummies\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdummy\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 861\u001b[0;31m         \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mconcat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mwith_dummies\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    862\u001b[0m     \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    863\u001b[0m         result = _get_dummies_1d(data, prefix, prefix_sep, dummy_na,\n",
      "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/core/reshape/concat.py\u001b[0m in \u001b[0;36mconcat\u001b[0;34m(objs, axis, join, join_axes, ignore_index, keys, levels, names, verify_integrity, sort, copy)\u001b[0m\n\u001b[1;32m    227\u001b[0m                        \u001b[0mverify_integrity\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mverify_integrity\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    228\u001b[0m                        copy=copy, sort=sort)\n\u001b[0;32m--> 229\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0mop\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_result\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    230\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    231\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/core/reshape/concat.py\u001b[0m in \u001b[0;36mget_result\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    424\u001b[0m             new_data = concatenate_block_managers(\n\u001b[1;32m    425\u001b[0m                 \u001b[0mmgrs_indexers\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnew_axes\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mconcat_axis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0maxis\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 426\u001b[0;31m                 copy=self.copy)\n\u001b[0m\u001b[1;32m    427\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcopy\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    428\u001b[0m                 \u001b[0mnew_data\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_consolidate_inplace\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/core/internals/managers.py\u001b[0m in \u001b[0;36mconcatenate_block_managers\u001b[0;34m(mgrs_indexers, axes, concat_axis, copy)\u001b[0m\n\u001b[1;32m   2050\u001b[0m             \u001b[0mvalues\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mb\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2051\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mcopy\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2052\u001b[0;31m                 \u001b[0mvalues\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mvalues\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcopy\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2053\u001b[0m             \u001b[0;32melif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mcopy\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2054\u001b[0m                 \u001b[0mvalues\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mvalues\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mview\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "df_group_expand = pd.get_dummies(df_group_expand, prefix='group')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 33001 entries, 9646 to 760605\n",
      "Columns: 6675 entries, group_age-1 age-217 age-731 age-739 age-333 age-393 age-988 age-366 age-608 age-942 age-638 to group_work-6\n",
      "dtypes: uint8(6675)\n",
      "memory usage: 211.6 MB\n"
     ]
    }
   ],
   "source": [
    "df_group_expand.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>group_age-1 age-217 age-731 age-739 age-333 age-393 age-988 age-366 age-608 age-942 age-638</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-333 age-393 age-741 age-819 age-479 age-608 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-739 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-333 age-741 age-819 age-479 age-608 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-739 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-522 age-79 age-229 age-202 age-333 age-393 age-829 age-741 age-819 age-479 age-608 age-433 age-394</th>\n",
       "      <th>...</th>\n",
       "      <th>group_status-5 status-9</th>\n",
       "      <th>group_status-6</th>\n",
       "      <th>group_status-6 status-9</th>\n",
       "      <th>group_status-7</th>\n",
       "      <th>group_status-7 status-11 status-15 status-6 status-14</th>\n",
       "      <th>group_status-7 status-11 status-2 status-15 status-6 status-14</th>\n",
       "      <th>group_status-7 status-2 status-15 status-6 status-14</th>\n",
       "      <th>group_status-7 status-9 status-15 status-6 status-14</th>\n",
       "      <th>group_status-9</th>\n",
       "      <th>group_work-6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9646</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9646</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9646</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9646</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9647</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 6675 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      group_age-1 age-217 age-731 age-739 age-333 age-393 age-988 age-366 age-608 age-942 age-638  \\\n",
       "9646                                                  0                                             \n",
       "9646                                                  0                                             \n",
       "9646                                                  0                                             \n",
       "9646                                                  0                                             \n",
       "9647                                                  0                                             \n",
       "\n",
       "      group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-333 age-393 age-741 age-819 age-479 age-608 age-433 age-394  \\\n",
       "9646                                                  0                                                                             \n",
       "9646                                                  0                                                                             \n",
       "9646                                                  0                                                                             \n",
       "9646                                                  0                                                                             \n",
       "9647                                                  0                                                                             \n",
       "\n",
       "      group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-433 age-394  \\\n",
       "9646                                                  0                                                                                             \n",
       "9646                                                  0                                                                                             \n",
       "9646                                                  0                                                                                             \n",
       "9646                                                  0                                                                                             \n",
       "9647                                                  0                                                                                             \n",
       "\n",
       "      group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394  \\\n",
       "9646                                                  0                                                                                                     \n",
       "9646                                                  0                                                                                                     \n",
       "9646                                                  0                                                                                                     \n",
       "9646                                                  0                                                                                                     \n",
       "9647                                                  0                                                                                                     \n",
       "\n",
       "      group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-739 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394  \\\n",
       "9646                                                  0                                                                                                             \n",
       "9646                                                  0                                                                                                             \n",
       "9646                                                  0                                                                                                             \n",
       "9646                                                  0                                                                                                             \n",
       "9647                                                  0                                                                                                             \n",
       "\n",
       "      group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-333 age-741 age-819 age-479 age-608 age-433 age-394  \\\n",
       "9646                                                  0                                                                             \n",
       "9646                                                  0                                                                             \n",
       "9646                                                  0                                                                             \n",
       "9646                                                  0                                                                             \n",
       "9647                                                  0                                                                             \n",
       "\n",
       "      group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-433 age-394  \\\n",
       "9646                                                  0                                                                                             \n",
       "9646                                                  0                                                                                             \n",
       "9646                                                  0                                                                                             \n",
       "9646                                                  0                                                                                             \n",
       "9647                                                  0                                                                                             \n",
       "\n",
       "      group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394  \\\n",
       "9646                                                  0                                                                                                             \n",
       "9646                                                  0                                                                                                             \n",
       "9646                                                  0                                                                                                             \n",
       "9646                                                  0                                                                                                             \n",
       "9647                                                  0                                                                                                             \n",
       "\n",
       "      group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-739 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394  \\\n",
       "9646                                                  0                                                                                                                     \n",
       "9646                                                  0                                                                                                                     \n",
       "9646                                                  0                                                                                                                     \n",
       "9646                                                  0                                                                                                                     \n",
       "9647                                                  0                                                                                                                     \n",
       "\n",
       "      group_age-1 age-347 age-787 age-753 age-601 age-522 age-79 age-229 age-202 age-333 age-393 age-829 age-741 age-819 age-479 age-608 age-433 age-394  \\\n",
       "9646                                                  0                                                                                                    \n",
       "9646                                                  0                                                                                                    \n",
       "9646                                                  0                                                                                                    \n",
       "9646                                                  0                                                                                                    \n",
       "9647                                                  0                                                                                                    \n",
       "\n",
       "      ...  group_status-5 status-9  group_status-6  group_status-6 status-9  \\\n",
       "9646  ...                        0               0                        0   \n",
       "9646  ...                        0               0                        0   \n",
       "9646  ...                        0               0                        0   \n",
       "9646  ...                        0               0                        0   \n",
       "9647  ...                        0               0                        0   \n",
       "\n",
       "      group_status-7  group_status-7 status-11 status-15 status-6 status-14  \\\n",
       "9646               0                                                  0       \n",
       "9646               0                                                  0       \n",
       "9646               0                                                  0       \n",
       "9646               0                                                  0       \n",
       "9647               0                                                  0       \n",
       "\n",
       "      group_status-7 status-11 status-2 status-15 status-6 status-14  \\\n",
       "9646                                                  0                \n",
       "9646                                                  0                \n",
       "9646                                                  0                \n",
       "9646                                                  0                \n",
       "9647                                                  0                \n",
       "\n",
       "      group_status-7 status-2 status-15 status-6 status-14  \\\n",
       "9646                                                  0      \n",
       "9646                                                  0      \n",
       "9646                                                  0      \n",
       "9646                                                  0      \n",
       "9647                                                  0      \n",
       "\n",
       "      group_status-7 status-9 status-15 status-6 status-14  group_status-9  \\\n",
       "9646                                                  0                  0   \n",
       "9646                                                  0                  0   \n",
       "9646                                                  0                  0   \n",
       "9646                                                  0                  0   \n",
       "9647                                                  0                  0   \n",
       "\n",
       "      group_work-6  \n",
       "9646             0  \n",
       "9646             0  \n",
       "9646             0  \n",
       "9646             0  \n",
       "9647             0  \n",
       "\n",
       "[5 rows x 6675 columns]"
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_group.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper_group_new = ad_oper_group[['ad-id', 'create-time']].join(df_group)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 33345 entries, 9646 to 760605\n",
      "Columns: 6677 entries, ad-id to group_work-6\n",
      "dtypes: float64(6675), int64(2)\n",
      "memory usage: 1.7 GB\n"
     ]
    }
   ],
   "source": [
    "ad_oper_group_new.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [],
   "source": [
    "ad_oper_group_new = ad_oper_group_new.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 33001 entries, 9646 to 760605\n",
      "Columns: 6677 entries, ad-id to group_work-6\n",
      "dtypes: float64(6675), int64(2)\n",
      "memory usage: 1.6 GB\n"
     ]
    }
   ],
   "source": [
    "ad_oper_group_new.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ad-id</th>\n",
       "      <th>create-time</th>\n",
       "      <th>group_age-1 age-217 age-731 age-739 age-333 age-393 age-988 age-366 age-608 age-942 age-638</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-333 age-393 age-741 age-819 age-479 age-608 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-739 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-333 age-741 age-819 age-479 age-608 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-433 age-394</th>\n",
       "      <th>group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9646</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190317174007</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9646</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190317174007</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9646</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190317174007</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9646</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190317174007</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9647</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102114</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9647</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102114</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9647</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102114</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9647</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102114</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9648</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102120</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9648</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102120</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9648</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102120</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9648</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102120</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9649</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102126</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9649</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102126</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9649</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102126</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9649</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102126</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9650</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102133</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9650</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102133</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9650</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102133</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9650</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102133</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9651</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102144</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9651</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102144</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9651</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102144</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9651</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319102144</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9652</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319103853</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9652</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319103853</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9652</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319103853</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9652</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319103853</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9653</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319103920</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9653</th>\n",
       "      <td>70365</td>\n",
       "      <td>20190319103920</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760117</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224828</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760117</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224828</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760117</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224828</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760118</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224831</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760118</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224831</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760118</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224831</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760119</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224916</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760119</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224916</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760119</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224916</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760120</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760120</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760120</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224931</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760121</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224937</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760121</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224937</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760121</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224937</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760122</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224943</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760122</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224943</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760122</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319224943</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760125</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319225141</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760125</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319225141</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760126</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319225158</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760126</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319225158</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760127</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319225207</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760127</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319225207</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760128</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319225210</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760128</th>\n",
       "      <td>19380</td>\n",
       "      <td>20190319225210</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760604</th>\n",
       "      <td>300864</td>\n",
       "      <td>20190319232840</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760604</th>\n",
       "      <td>300864</td>\n",
       "      <td>20190319232840</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760605</th>\n",
       "      <td>300864</td>\n",
       "      <td>20190319232842</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760605</th>\n",
       "      <td>300864</td>\n",
       "      <td>20190319232842</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33001 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         ad-id     create-time  \\\n",
       "9646     70365  20190317174007   \n",
       "9646     70365  20190317174007   \n",
       "9646     70365  20190317174007   \n",
       "9646     70365  20190317174007   \n",
       "9647     70365  20190319102114   \n",
       "9647     70365  20190319102114   \n",
       "9647     70365  20190319102114   \n",
       "9647     70365  20190319102114   \n",
       "9648     70365  20190319102120   \n",
       "9648     70365  20190319102120   \n",
       "9648     70365  20190319102120   \n",
       "9648     70365  20190319102120   \n",
       "9649     70365  20190319102126   \n",
       "9649     70365  20190319102126   \n",
       "9649     70365  20190319102126   \n",
       "9649     70365  20190319102126   \n",
       "9650     70365  20190319102133   \n",
       "9650     70365  20190319102133   \n",
       "9650     70365  20190319102133   \n",
       "9650     70365  20190319102133   \n",
       "9651     70365  20190319102144   \n",
       "9651     70365  20190319102144   \n",
       "9651     70365  20190319102144   \n",
       "9651     70365  20190319102144   \n",
       "9652     70365  20190319103853   \n",
       "9652     70365  20190319103853   \n",
       "9652     70365  20190319103853   \n",
       "9652     70365  20190319103853   \n",
       "9653     70365  20190319103920   \n",
       "9653     70365  20190319103920   \n",
       "...        ...             ...   \n",
       "760117   19380  20190319224828   \n",
       "760117   19380  20190319224828   \n",
       "760117   19380  20190319224828   \n",
       "760118   19380  20190319224831   \n",
       "760118   19380  20190319224831   \n",
       "760118   19380  20190319224831   \n",
       "760119   19380  20190319224916   \n",
       "760119   19380  20190319224916   \n",
       "760119   19380  20190319224916   \n",
       "760120   19380  20190319224931   \n",
       "760120   19380  20190319224931   \n",
       "760120   19380  20190319224931   \n",
       "760121   19380  20190319224937   \n",
       "760121   19380  20190319224937   \n",
       "760121   19380  20190319224937   \n",
       "760122   19380  20190319224943   \n",
       "760122   19380  20190319224943   \n",
       "760122   19380  20190319224943   \n",
       "760125   19380  20190319225141   \n",
       "760125   19380  20190319225141   \n",
       "760126   19380  20190319225158   \n",
       "760126   19380  20190319225158   \n",
       "760127   19380  20190319225207   \n",
       "760127   19380  20190319225207   \n",
       "760128   19380  20190319225210   \n",
       "760128   19380  20190319225210   \n",
       "760604  300864  20190319232840   \n",
       "760604  300864  20190319232840   \n",
       "760605  300864  20190319232842   \n",
       "760605  300864  20190319232842   \n",
       "\n",
       "        group_age-1 age-217 age-731 age-739 age-333 age-393 age-988 age-366 age-608 age-942 age-638  \\\n",
       "9646                                                  0.0                                             \n",
       "9646                                                  0.0                                             \n",
       "9646                                                  0.0                                             \n",
       "9646                                                  0.0                                             \n",
       "9647                                                  0.0                                             \n",
       "9647                                                  0.0                                             \n",
       "9647                                                  0.0                                             \n",
       "9647                                                  0.0                                             \n",
       "9648                                                  0.0                                             \n",
       "9648                                                  0.0                                             \n",
       "9648                                                  0.0                                             \n",
       "9648                                                  0.0                                             \n",
       "9649                                                  0.0                                             \n",
       "9649                                                  0.0                                             \n",
       "9649                                                  0.0                                             \n",
       "9649                                                  0.0                                             \n",
       "9650                                                  0.0                                             \n",
       "9650                                                  0.0                                             \n",
       "9650                                                  0.0                                             \n",
       "9650                                                  0.0                                             \n",
       "9651                                                  0.0                                             \n",
       "9651                                                  0.0                                             \n",
       "9651                                                  0.0                                             \n",
       "9651                                                  0.0                                             \n",
       "9652                                                  0.0                                             \n",
       "9652                                                  0.0                                             \n",
       "9652                                                  0.0                                             \n",
       "9652                                                  0.0                                             \n",
       "9653                                                  0.0                                             \n",
       "9653                                                  0.0                                             \n",
       "...                                                   ...                                             \n",
       "760117                                                0.0                                             \n",
       "760117                                                0.0                                             \n",
       "760117                                                0.0                                             \n",
       "760118                                                0.0                                             \n",
       "760118                                                0.0                                             \n",
       "760118                                                0.0                                             \n",
       "760119                                                0.0                                             \n",
       "760119                                                0.0                                             \n",
       "760119                                                0.0                                             \n",
       "760120                                                0.0                                             \n",
       "760120                                                0.0                                             \n",
       "760120                                                0.0                                             \n",
       "760121                                                0.0                                             \n",
       "760121                                                0.0                                             \n",
       "760121                                                0.0                                             \n",
       "760122                                                0.0                                             \n",
       "760122                                                0.0                                             \n",
       "760122                                                0.0                                             \n",
       "760125                                                0.0                                             \n",
       "760125                                                0.0                                             \n",
       "760126                                                0.0                                             \n",
       "760126                                                0.0                                             \n",
       "760127                                                0.0                                             \n",
       "760127                                                0.0                                             \n",
       "760128                                                0.0                                             \n",
       "760128                                                0.0                                             \n",
       "760604                                                0.0                                             \n",
       "760604                                                0.0                                             \n",
       "760605                                                0.0                                             \n",
       "760605                                                0.0                                             \n",
       "\n",
       "        group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-333 age-393 age-741 age-819 age-479 age-608 age-433 age-394  \\\n",
       "9646                                                  0.0                                                                             \n",
       "9646                                                  0.0                                                                             \n",
       "9646                                                  0.0                                                                             \n",
       "9646                                                  0.0                                                                             \n",
       "9647                                                  0.0                                                                             \n",
       "9647                                                  0.0                                                                             \n",
       "9647                                                  0.0                                                                             \n",
       "9647                                                  0.0                                                                             \n",
       "9648                                                  0.0                                                                             \n",
       "9648                                                  0.0                                                                             \n",
       "9648                                                  0.0                                                                             \n",
       "9648                                                  0.0                                                                             \n",
       "9649                                                  0.0                                                                             \n",
       "9649                                                  0.0                                                                             \n",
       "9649                                                  0.0                                                                             \n",
       "9649                                                  0.0                                                                             \n",
       "9650                                                  0.0                                                                             \n",
       "9650                                                  0.0                                                                             \n",
       "9650                                                  0.0                                                                             \n",
       "9650                                                  0.0                                                                             \n",
       "9651                                                  0.0                                                                             \n",
       "9651                                                  0.0                                                                             \n",
       "9651                                                  0.0                                                                             \n",
       "9651                                                  0.0                                                                             \n",
       "9652                                                  0.0                                                                             \n",
       "9652                                                  0.0                                                                             \n",
       "9652                                                  0.0                                                                             \n",
       "9652                                                  0.0                                                                             \n",
       "9653                                                  0.0                                                                             \n",
       "9653                                                  0.0                                                                             \n",
       "...                                                   ...                                                                             \n",
       "760117                                                0.0                                                                             \n",
       "760117                                                0.0                                                                             \n",
       "760117                                                0.0                                                                             \n",
       "760118                                                0.0                                                                             \n",
       "760118                                                0.0                                                                             \n",
       "760118                                                0.0                                                                             \n",
       "760119                                                0.0                                                                             \n",
       "760119                                                0.0                                                                             \n",
       "760119                                                0.0                                                                             \n",
       "760120                                                0.0                                                                             \n",
       "760120                                                0.0                                                                             \n",
       "760120                                                0.0                                                                             \n",
       "760121                                                0.0                                                                             \n",
       "760121                                                0.0                                                                             \n",
       "760121                                                0.0                                                                             \n",
       "760122                                                0.0                                                                             \n",
       "760122                                                0.0                                                                             \n",
       "760122                                                0.0                                                                             \n",
       "760125                                                0.0                                                                             \n",
       "760125                                                0.0                                                                             \n",
       "760126                                                0.0                                                                             \n",
       "760126                                                0.0                                                                             \n",
       "760127                                                0.0                                                                             \n",
       "760127                                                0.0                                                                             \n",
       "760128                                                0.0                                                                             \n",
       "760128                                                0.0                                                                             \n",
       "760604                                                0.0                                                                             \n",
       "760604                                                0.0                                                                             \n",
       "760605                                                0.0                                                                             \n",
       "760605                                                0.0                                                                             \n",
       "\n",
       "        group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-433 age-394  \\\n",
       "9646                                                  0.0                                                                                             \n",
       "9646                                                  0.0                                                                                             \n",
       "9646                                                  0.0                                                                                             \n",
       "9646                                                  0.0                                                                                             \n",
       "9647                                                  0.0                                                                                             \n",
       "9647                                                  0.0                                                                                             \n",
       "9647                                                  0.0                                                                                             \n",
       "9647                                                  0.0                                                                                             \n",
       "9648                                                  0.0                                                                                             \n",
       "9648                                                  0.0                                                                                             \n",
       "9648                                                  0.0                                                                                             \n",
       "9648                                                  0.0                                                                                             \n",
       "9649                                                  0.0                                                                                             \n",
       "9649                                                  0.0                                                                                             \n",
       "9649                                                  0.0                                                                                             \n",
       "9649                                                  0.0                                                                                             \n",
       "9650                                                  0.0                                                                                             \n",
       "9650                                                  0.0                                                                                             \n",
       "9650                                                  0.0                                                                                             \n",
       "9650                                                  0.0                                                                                             \n",
       "9651                                                  0.0                                                                                             \n",
       "9651                                                  0.0                                                                                             \n",
       "9651                                                  0.0                                                                                             \n",
       "9651                                                  0.0                                                                                             \n",
       "9652                                                  0.0                                                                                             \n",
       "9652                                                  0.0                                                                                             \n",
       "9652                                                  0.0                                                                                             \n",
       "9652                                                  0.0                                                                                             \n",
       "9653                                                  0.0                                                                                             \n",
       "9653                                                  0.0                                                                                             \n",
       "...                                                   ...                                                                                             \n",
       "760117                                                0.0                                                                                             \n",
       "760117                                                0.0                                                                                             \n",
       "760117                                                0.0                                                                                             \n",
       "760118                                                0.0                                                                                             \n",
       "760118                                                0.0                                                                                             \n",
       "760118                                                0.0                                                                                             \n",
       "760119                                                0.0                                                                                             \n",
       "760119                                                0.0                                                                                             \n",
       "760119                                                0.0                                                                                             \n",
       "760120                                                0.0                                                                                             \n",
       "760120                                                0.0                                                                                             \n",
       "760120                                                0.0                                                                                             \n",
       "760121                                                0.0                                                                                             \n",
       "760121                                                0.0                                                                                             \n",
       "760121                                                0.0                                                                                             \n",
       "760122                                                0.0                                                                                             \n",
       "760122                                                0.0                                                                                             \n",
       "760122                                                0.0                                                                                             \n",
       "760125                                                0.0                                                                                             \n",
       "760125                                                0.0                                                                                             \n",
       "760126                                                0.0                                                                                             \n",
       "760126                                                0.0                                                                                             \n",
       "760127                                                0.0                                                                                             \n",
       "760127                                                0.0                                                                                             \n",
       "760128                                                0.0                                                                                             \n",
       "760128                                                0.0                                                                                             \n",
       "760604                                                0.0                                                                                             \n",
       "760604                                                0.0                                                                                             \n",
       "760605                                                0.0                                                                                             \n",
       "760605                                                0.0                                                                                             \n",
       "\n",
       "        group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394  \\\n",
       "9646                                                  0.0                                                                                                     \n",
       "9646                                                  0.0                                                                                                     \n",
       "9646                                                  0.0                                                                                                     \n",
       "9646                                                  0.0                                                                                                     \n",
       "9647                                                  0.0                                                                                                     \n",
       "9647                                                  0.0                                                                                                     \n",
       "9647                                                  0.0                                                                                                     \n",
       "9647                                                  0.0                                                                                                     \n",
       "9648                                                  0.0                                                                                                     \n",
       "9648                                                  0.0                                                                                                     \n",
       "9648                                                  0.0                                                                                                     \n",
       "9648                                                  0.0                                                                                                     \n",
       "9649                                                  0.0                                                                                                     \n",
       "9649                                                  0.0                                                                                                     \n",
       "9649                                                  0.0                                                                                                     \n",
       "9649                                                  0.0                                                                                                     \n",
       "9650                                                  0.0                                                                                                     \n",
       "9650                                                  0.0                                                                                                     \n",
       "9650                                                  0.0                                                                                                     \n",
       "9650                                                  0.0                                                                                                     \n",
       "9651                                                  0.0                                                                                                     \n",
       "9651                                                  0.0                                                                                                     \n",
       "9651                                                  0.0                                                                                                     \n",
       "9651                                                  0.0                                                                                                     \n",
       "9652                                                  0.0                                                                                                     \n",
       "9652                                                  0.0                                                                                                     \n",
       "9652                                                  0.0                                                                                                     \n",
       "9652                                                  0.0                                                                                                     \n",
       "9653                                                  0.0                                                                                                     \n",
       "9653                                                  0.0                                                                                                     \n",
       "...                                                   ...                                                                                                     \n",
       "760117                                                0.0                                                                                                     \n",
       "760117                                                0.0                                                                                                     \n",
       "760117                                                0.0                                                                                                     \n",
       "760118                                                0.0                                                                                                     \n",
       "760118                                                0.0                                                                                                     \n",
       "760118                                                0.0                                                                                                     \n",
       "760119                                                0.0                                                                                                     \n",
       "760119                                                0.0                                                                                                     \n",
       "760119                                                0.0                                                                                                     \n",
       "760120                                                0.0                                                                                                     \n",
       "760120                                                0.0                                                                                                     \n",
       "760120                                                0.0                                                                                                     \n",
       "760121                                                0.0                                                                                                     \n",
       "760121                                                0.0                                                                                                     \n",
       "760121                                                0.0                                                                                                     \n",
       "760122                                                0.0                                                                                                     \n",
       "760122                                                0.0                                                                                                     \n",
       "760122                                                0.0                                                                                                     \n",
       "760125                                                0.0                                                                                                     \n",
       "760125                                                0.0                                                                                                     \n",
       "760126                                                0.0                                                                                                     \n",
       "760126                                                0.0                                                                                                     \n",
       "760127                                                0.0                                                                                                     \n",
       "760127                                                0.0                                                                                                     \n",
       "760128                                                0.0                                                                                                     \n",
       "760128                                                0.0                                                                                                     \n",
       "760604                                                0.0                                                                                                     \n",
       "760604                                                0.0                                                                                                     \n",
       "760605                                                0.0                                                                                                     \n",
       "760605                                                0.0                                                                                                     \n",
       "\n",
       "        group_age-1 age-347 age-787 age-753 age-601 age-202 age-229 age-731 age-739 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394  \\\n",
       "9646                                                  0.0                                                                                                             \n",
       "9646                                                  0.0                                                                                                             \n",
       "9646                                                  0.0                                                                                                             \n",
       "9646                                                  0.0                                                                                                             \n",
       "9647                                                  0.0                                                                                                             \n",
       "9647                                                  0.0                                                                                                             \n",
       "9647                                                  0.0                                                                                                             \n",
       "9647                                                  0.0                                                                                                             \n",
       "9648                                                  0.0                                                                                                             \n",
       "9648                                                  0.0                                                                                                             \n",
       "9648                                                  0.0                                                                                                             \n",
       "9648                                                  0.0                                                                                                             \n",
       "9649                                                  0.0                                                                                                             \n",
       "9649                                                  0.0                                                                                                             \n",
       "9649                                                  0.0                                                                                                             \n",
       "9649                                                  0.0                                                                                                             \n",
       "9650                                                  0.0                                                                                                             \n",
       "9650                                                  0.0                                                                                                             \n",
       "9650                                                  0.0                                                                                                             \n",
       "9650                                                  0.0                                                                                                             \n",
       "9651                                                  0.0                                                                                                             \n",
       "9651                                                  0.0                                                                                                             \n",
       "9651                                                  0.0                                                                                                             \n",
       "9651                                                  0.0                                                                                                             \n",
       "9652                                                  0.0                                                                                                             \n",
       "9652                                                  0.0                                                                                                             \n",
       "9652                                                  0.0                                                                                                             \n",
       "9652                                                  0.0                                                                                                             \n",
       "9653                                                  0.0                                                                                                             \n",
       "9653                                                  0.0                                                                                                             \n",
       "...                                                   ...                                                                                                             \n",
       "760117                                                0.0                                                                                                             \n",
       "760117                                                0.0                                                                                                             \n",
       "760117                                                0.0                                                                                                             \n",
       "760118                                                0.0                                                                                                             \n",
       "760118                                                0.0                                                                                                             \n",
       "760118                                                0.0                                                                                                             \n",
       "760119                                                0.0                                                                                                             \n",
       "760119                                                0.0                                                                                                             \n",
       "760119                                                0.0                                                                                                             \n",
       "760120                                                0.0                                                                                                             \n",
       "760120                                                0.0                                                                                                             \n",
       "760120                                                0.0                                                                                                             \n",
       "760121                                                0.0                                                                                                             \n",
       "760121                                                0.0                                                                                                             \n",
       "760121                                                0.0                                                                                                             \n",
       "760122                                                0.0                                                                                                             \n",
       "760122                                                0.0                                                                                                             \n",
       "760122                                                0.0                                                                                                             \n",
       "760125                                                0.0                                                                                                             \n",
       "760125                                                0.0                                                                                                             \n",
       "760126                                                0.0                                                                                                             \n",
       "760126                                                0.0                                                                                                             \n",
       "760127                                                0.0                                                                                                             \n",
       "760127                                                0.0                                                                                                             \n",
       "760128                                                0.0                                                                                                             \n",
       "760128                                                0.0                                                                                                             \n",
       "760604                                                0.0                                                                                                             \n",
       "760604                                                0.0                                                                                                             \n",
       "760605                                                0.0                                                                                                             \n",
       "760605                                                0.0                                                                                                             \n",
       "\n",
       "        group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-333 age-741 age-819 age-479 age-608 age-433 age-394  \\\n",
       "9646                                                  0.0                                                                             \n",
       "9646                                                  0.0                                                                             \n",
       "9646                                                  0.0                                                                             \n",
       "9646                                                  0.0                                                                             \n",
       "9647                                                  0.0                                                                             \n",
       "9647                                                  0.0                                                                             \n",
       "9647                                                  0.0                                                                             \n",
       "9647                                                  0.0                                                                             \n",
       "9648                                                  0.0                                                                             \n",
       "9648                                                  0.0                                                                             \n",
       "9648                                                  0.0                                                                             \n",
       "9648                                                  0.0                                                                             \n",
       "9649                                                  0.0                                                                             \n",
       "9649                                                  0.0                                                                             \n",
       "9649                                                  0.0                                                                             \n",
       "9649                                                  0.0                                                                             \n",
       "9650                                                  0.0                                                                             \n",
       "9650                                                  0.0                                                                             \n",
       "9650                                                  0.0                                                                             \n",
       "9650                                                  0.0                                                                             \n",
       "9651                                                  0.0                                                                             \n",
       "9651                                                  0.0                                                                             \n",
       "9651                                                  0.0                                                                             \n",
       "9651                                                  0.0                                                                             \n",
       "9652                                                  0.0                                                                             \n",
       "9652                                                  0.0                                                                             \n",
       "9652                                                  0.0                                                                             \n",
       "9652                                                  0.0                                                                             \n",
       "9653                                                  0.0                                                                             \n",
       "9653                                                  0.0                                                                             \n",
       "...                                                   ...                                                                             \n",
       "760117                                                0.0                                                                             \n",
       "760117                                                0.0                                                                             \n",
       "760117                                                0.0                                                                             \n",
       "760118                                                0.0                                                                             \n",
       "760118                                                0.0                                                                             \n",
       "760118                                                0.0                                                                             \n",
       "760119                                                0.0                                                                             \n",
       "760119                                                0.0                                                                             \n",
       "760119                                                0.0                                                                             \n",
       "760120                                                0.0                                                                             \n",
       "760120                                                0.0                                                                             \n",
       "760120                                                0.0                                                                             \n",
       "760121                                                0.0                                                                             \n",
       "760121                                                0.0                                                                             \n",
       "760121                                                0.0                                                                             \n",
       "760122                                                0.0                                                                             \n",
       "760122                                                0.0                                                                             \n",
       "760122                                                0.0                                                                             \n",
       "760125                                                0.0                                                                             \n",
       "760125                                                0.0                                                                             \n",
       "760126                                                0.0                                                                             \n",
       "760126                                                0.0                                                                             \n",
       "760127                                                0.0                                                                             \n",
       "760127                                                0.0                                                                             \n",
       "760128                                                0.0                                                                             \n",
       "760128                                                0.0                                                                             \n",
       "760604                                                0.0                                                                             \n",
       "760604                                                0.0                                                                             \n",
       "760605                                                0.0                                                                             \n",
       "760605                                                0.0                                                                             \n",
       "\n",
       "        group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-433 age-394  \\\n",
       "9646                                                  0.0                                                                                             \n",
       "9646                                                  0.0                                                                                             \n",
       "9646                                                  0.0                                                                                             \n",
       "9646                                                  0.0                                                                                             \n",
       "9647                                                  0.0                                                                                             \n",
       "9647                                                  0.0                                                                                             \n",
       "9647                                                  0.0                                                                                             \n",
       "9647                                                  0.0                                                                                             \n",
       "9648                                                  0.0                                                                                             \n",
       "9648                                                  0.0                                                                                             \n",
       "9648                                                  0.0                                                                                             \n",
       "9648                                                  0.0                                                                                             \n",
       "9649                                                  0.0                                                                                             \n",
       "9649                                                  0.0                                                                                             \n",
       "9649                                                  0.0                                                                                             \n",
       "9649                                                  0.0                                                                                             \n",
       "9650                                                  0.0                                                                                             \n",
       "9650                                                  0.0                                                                                             \n",
       "9650                                                  0.0                                                                                             \n",
       "9650                                                  0.0                                                                                             \n",
       "9651                                                  0.0                                                                                             \n",
       "9651                                                  0.0                                                                                             \n",
       "9651                                                  0.0                                                                                             \n",
       "9651                                                  0.0                                                                                             \n",
       "9652                                                  0.0                                                                                             \n",
       "9652                                                  0.0                                                                                             \n",
       "9652                                                  0.0                                                                                             \n",
       "9652                                                  0.0                                                                                             \n",
       "9653                                                  0.0                                                                                             \n",
       "9653                                                  0.0                                                                                             \n",
       "...                                                   ...                                                                                             \n",
       "760117                                                0.0                                                                                             \n",
       "760117                                                0.0                                                                                             \n",
       "760117                                                0.0                                                                                             \n",
       "760118                                                0.0                                                                                             \n",
       "760118                                                0.0                                                                                             \n",
       "760118                                                0.0                                                                                             \n",
       "760119                                                0.0                                                                                             \n",
       "760119                                                0.0                                                                                             \n",
       "760119                                                0.0                                                                                             \n",
       "760120                                                0.0                                                                                             \n",
       "760120                                                0.0                                                                                             \n",
       "760120                                                0.0                                                                                             \n",
       "760121                                                0.0                                                                                             \n",
       "760121                                                0.0                                                                                             \n",
       "760121                                                0.0                                                                                             \n",
       "760122                                                0.0                                                                                             \n",
       "760122                                                0.0                                                                                             \n",
       "760122                                                0.0                                                                                             \n",
       "760125                                                0.0                                                                                             \n",
       "760125                                                0.0                                                                                             \n",
       "760126                                                0.0                                                                                             \n",
       "760126                                                0.0                                                                                             \n",
       "760127                                                0.0                                                                                             \n",
       "760127                                                0.0                                                                                             \n",
       "760128                                                0.0                                                                                             \n",
       "760128                                                0.0                                                                                             \n",
       "760604                                                0.0                                                                                             \n",
       "760604                                                0.0                                                                                             \n",
       "760605                                                0.0                                                                                             \n",
       "760605                                                0.0                                                                                             \n",
       "\n",
       "        group_age-1 age-347 age-787 age-753 age-601 age-522 age-202 age-229 age-731 age-333 age-393 age-741 age-819 age-479 age-608 age-942 age-638 age-433 age-394  \n",
       "9646                                                  0.0                                                                                                            \n",
       "9646                                                  0.0                                                                                                            \n",
       "9646                                                  0.0                                                                                                            \n",
       "9646                                                  0.0                                                                                                            \n",
       "9647                                                  0.0                                                                                                            \n",
       "9647                                                  0.0                                                                                                            \n",
       "9647                                                  0.0                                                                                                            \n",
       "9647                                                  0.0                                                                                                            \n",
       "9648                                                  0.0                                                                                                            \n",
       "9648                                                  0.0                                                                                                            \n",
       "9648                                                  0.0                                                                                                            \n",
       "9648                                                  0.0                                                                                                            \n",
       "9649                                                  0.0                                                                                                            \n",
       "9649                                                  0.0                                                                                                            \n",
       "9649                                                  0.0                                                                                                            \n",
       "9649                                                  0.0                                                                                                            \n",
       "9650                                                  0.0                                                                                                            \n",
       "9650                                                  0.0                                                                                                            \n",
       "9650                                                  0.0                                                                                                            \n",
       "9650                                                  0.0                                                                                                            \n",
       "9651                                                  0.0                                                                                                            \n",
       "9651                                                  0.0                                                                                                            \n",
       "9651                                                  0.0                                                                                                            \n",
       "9651                                                  0.0                                                                                                            \n",
       "9652                                                  0.0                                                                                                            \n",
       "9652                                                  0.0                                                                                                            \n",
       "9652                                                  0.0                                                                                                            \n",
       "9652                                                  0.0                                                                                                            \n",
       "9653                                                  0.0                                                                                                            \n",
       "9653                                                  0.0                                                                                                            \n",
       "...                                                   ...                                                                                                            \n",
       "760117                                                0.0                                                                                                            \n",
       "760117                                                0.0                                                                                                            \n",
       "760117                                                0.0                                                                                                            \n",
       "760118                                                0.0                                                                                                            \n",
       "760118                                                0.0                                                                                                            \n",
       "760118                                                0.0                                                                                                            \n",
       "760119                                                0.0                                                                                                            \n",
       "760119                                                0.0                                                                                                            \n",
       "760119                                                0.0                                                                                                            \n",
       "760120                                                0.0                                                                                                            \n",
       "760120                                                0.0                                                                                                            \n",
       "760120                                                0.0                                                                                                            \n",
       "760121                                                0.0                                                                                                            \n",
       "760121                                                0.0                                                                                                            \n",
       "760121                                                0.0                                                                                                            \n",
       "760122                                                0.0                                                                                                            \n",
       "760122                                                0.0                                                                                                            \n",
       "760122                                                0.0                                                                                                            \n",
       "760125                                                0.0                                                                                                            \n",
       "760125                                                0.0                                                                                                            \n",
       "760126                                                0.0                                                                                                            \n",
       "760126                                                0.0                                                                                                            \n",
       "760127                                                0.0                                                                                                            \n",
       "760127                                                0.0                                                                                                            \n",
       "760128                                                0.0                                                                                                            \n",
       "760128                                                0.0                                                                                                            \n",
       "760604                                                0.0                                                                                                            \n",
       "760604                                                0.0                                                                                                            \n",
       "760605                                                0.0                                                                                                            \n",
       "760605                                                0.0                                                                                                            \n",
       "\n",
       "[33001 rows x 10 columns]"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ad_oper_group_new.iloc[:, 0:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
